SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwrProveedores
AS
SELECT     idProveedor AS ID, RazonSocial
FROM         dbo.tb_Proveedores
GO
GRANT SELECT ON  [dbo].[vwrProveedores] TO [AdministracionEscolar]
GRANT SELECT ON  [dbo].[vwrProveedores] TO [GestionComprasySuministros]
GRANT SELECT ON  [dbo].[vwrProveedores] TO [GestionContable]
GRANT SELECT ON  [dbo].[vwrProveedores] TO [GestionDeposito]
GRANT SELECT ON  [dbo].[vwrProveedores] TO [GestionInventario]
GRANT SELECT ON  [dbo].[vwrProveedores] TO [GestionServiciosEscolares]
GRANT SELECT ON  [dbo].[vwrProveedores] TO [GestionSubsidiosyRendiciones]
GRANT SELECT ON  [dbo].[vwrProveedores] TO [Informatica]
GRANT SELECT ON  [dbo].[vwrProveedores] TO [SoloVer]
GO
